Scotland's Government has stepped back from demanding a minimum price on alcoholic drinks in the face of strong opposition from other political parties.