Former West Ham player and manager Sir Trevor Brooking expects Wednesday's final match at the Boleyn Ground against Manchester United to be emotional.