Holyrood hears of 'painful' and 'undignified' Orkney flight