More than one in four secondary school pupils say they are unmotivated in the classroom, a new Government survey has found.