Cities are increasing investment in the green transition to protect against the potentially catastrophic effects of climate change, the European Investment Bank president said.