Scottish musician also played with David Bowie; in 1995 he composed a piece of music he said marked the liberation of Auschwitz, which he considered his most important solo work