Sir Keir Starmer’s popularity in Scotland sinks amid Labour split over North Sea oil