Tesco has agreed to not sell beer and cider stronger than 5.5% abv in order to secure an alcohol licence from a Scottish council.