More than half of parents do not think sex education should be taught to children at school, according to a survey.