The Church of England has said that sex is for straight married couples only while declaring that Christians in gay or straight civil partnerships should be sexually abstinent.