He's one of Scotland's finest ever Olympians - but even Sir Chris Hoy is capable of being awestruck by sporting greats