First Minister John Swinney has paid tribute to the many Scots who have been recognised for their exceptional contributions to public life.