Rod Stewart and Tim Peake among those honoured in the queen's birthday list