David declared himself 'immensely proud' as he finally received a knighthood after years of being snubbed