Sir Chris Hoy was diagnosed with stage 4 prostate cancer in September 2023, and has since campaigned for more awareness