Brexit sparks shift in foreign investors' attitude to UK