Germany’s foreign minister called the result a “bitter defeat” after it lost a seat at the UN Security Council for the first time since the country’s reunification.