Sir Roderick joins classic rockers Paul McCartney, Elton John, Mick Jagger, Tom Jones and Van Morrison as a British knight