The alcohol ban in Scotland could eventually be lifted after being in place for 45 years.