An Irish guitarist has told how he became the only musician on the planet handpicked to write songs with David Bowie for his new album.