The former Manchester United and England star, who recently celebrated his milestone 50th birthday, will be confirmed as a 'Sir' when the list is released next week