The Bishop of Grantham has become the first in the Church of England to publicly reveal that he is gay and in a relationship.