An exhibition at Sir John Soane’s Museum reveals the continued importance of the classical ideal