The artist Archie Brennan knew Sir Sean Connery, collaborated with David Hockney and his work was bought by The Great British Bake Off judge Prue Leith. Yet the man dubbed "Scotland's Andy Warhol ...