Andy Burnham had previously told First Minister John Swinney that a second referendum is "off limits".