The bishop of Grantham has become the first Church of England bishop to say that he is gay and in a relationship.