New attitudes towards environmental, social and governance (ESG) investing are emerging, as investors believe it will become "standard practice" soon, a survey has found.