Liam McArthur, the MSP behind the bill, said many of those who voted against it would come to regret it deeply