Queen Elizabeth II was left ‘very tired and exhausted’ during bout of Covid