Former England manager Gareth Southgate has been awarded a knighthood in the New Year Honours.