Scottish MPs have agreed that minimum alcohol pricing could be scrapped after six years if the policy fails.