Is it true that the Sunnah is to drink water while sitting, except for Zamzam water, which it is preferable to drink while standing?

It is from the Sunnah to drink while sitting. However, it is authentically reported that the Prophet, peace be upon him, drank from Zamzam while standing due to necessity. Scholars have differed regarding the ruling on this matter: some said it abrogates the prohibition, some said the prohibition is not for حرمة (prohibition) but for إرشاد (guidance), and some said there is no contradiction between the two because he drank while standing out of necessity.