Germany concedes 'bitter defeat' after failed bid for non-permanent seat on UN Security Council