Light doesn't attenuate significantly in the air, unlike water where it quickly fades. However, it will spread out more. Do the optimum hight should be determined by how wide an area you need light based on the beam width of the light.
Simply said, adjust the light hight until the area of the tank you want lit, is.
__________________
|