The top ranking school for pupil happiness has been revealed in new data.