David Beckham 'has given up hope of a knighthood in the near future'