Manchester United legend George Best is “severely ill” in hospital after his condition deteriorated, his consultant has said.