Di-photon Higgs signal at the LHC: A comparative study in different supersymmetric models