Four-time Commonwealth Games cycling medallist Ross Edgar says he is "surprised" and "honoured" to be asked to carry the Scottish flag and lead the squad during the opening ceremony.