Former prime minister Rishi Sunak has said he is “honoured” to become an ambassador for a prostate cancer charity, during a visit to Oxford.