Spire Healthcare - the UK's largest private hospital operator - has agreed to be taken over by a consortium of investment firms in a deal worth £1 billion.