The Scottish Parliament has symbolically rejected any no-deal Brexit, despite opposition from Conservative MSPs.