China and India have overtaken the US to become the two most attractive nations for renewable energy investment – according to a report.