Next Bishop of Manchester formally confirmed at York Minster