The Church of England has offered an “unreserved apology” for historic cases of child abuse by some members of its clergy.