MSPs have voted to tighten the law on off-sales and devolve the decision on pub opening hours to local licensing boards amid chaotic scenes.