Former Scotsman editor honoured with CBE Journalist led title for six years before going to national newspaper