From views on gay sex to women’s role in the home, British social attitudes survey reveals a ‘near revolution’