By which effect the coin placed at the bottom of the water tank seems some upper?

When light travels from one medium to another at the interface the light changes its direction or light bends. This effect is known as Refraction. When light travels from rarer medium to denser medium, the light bends towards the normal and this causes object to appear nearer than they are.