Ecstatic scenes greeted the final whistle as Burnley sealed their promotion back to the Premier League.