Triple gold medallist Chris Hoy was the star of an open-top bus parade for Scotland's Olympic heroes.