MSPs have refused to give legislative consent to the UK Government’s post-Brexit subsidy bill which would cause “further erosion of the devolution settlement”.