The writing appears to be on the wall for Sir Keir Starmer, and Labour desperately needs a leader who can see off the dual threats of the Greens and Reform UK. Sean O’Grady asks whether the ‘King of the North’ could be the party’s knight in shining armour, even if there’s a by-election in his way