Passengers are no longer allowed to drink alcohol late at night or early in the morning on most Scottish trains.