Investigations on the structural and optical properties of band gap engineered Zn1−x(Cd, Mg)xO thin films deposited by sol–gel technique