Standard Chartered's decision to withdraw its support from the giant Carmichael coal mine in Australia has been welcomed by a leading investor.