Wayne Rooney's late header secured victory for Manchester United over CSKA Moscow in Champions League Group B in front of a nervy Old Trafford crowd.