Scott Wiener handed retiring Rep. Nancy Pelosi a rare loss in her home city at the tail end of a historic, nearly 40-year run in Congress by defeating her handpicked successor.