Prime Minister Andy Burnham has triggered a political storm after suggesting a second Scottish independence referendum could be permitted if public opinion shifts.