Sir Chris Hoy won six Olympic gold medals in a storied career at the elite level of track cycling but is now battling a terminal cancer diagnosis