Cases with DEFAULT and NULL does not work

Correct answer is to use:

nextval('"Photo_AuthorID_seq"'::regclass)

In dbeaver you may find this value in properties tab for primary key