“I only asked them to play on my album because the record company thought a few well-known names would be a good selling point”: Snowy White tells the story of his 1994 collaboration with Gary Moore and David Gilmour