I am sure they'll be SNP MSPs who are not particularly happy about the legislation - I suspect the Scottish Government will amend rather than repeal it.
As it currently stands the law is unworkable and unenforceable.
It was ill-thought gesture politics at its worst. That being said - repeal of the legislation will not make one iota of a difference either.