Sir Chris Hoy was diagnosed with stage four prostate cancer in September 2023 and has now shared a hopeful update on his health