Whisky led a record increase in Scottish drinks exports in 2009, according to Scottish Development International (SDI).