German Chancellor Olaf Scholz has admitted his Social Democratic Party (SPD) has suffered a "bitter election result," after projections showed the party plunging to its worst performance in the country's post-war history.