MSPs have backed a call to cancel Brexit in the event that another referendum cannot take place, in a largely symbolic vote.