Sequence for primary key which exists multiple times, Sql Server

Language: Layout:

if object_id(N'dbo.NewsIdSequence') is null
  begin;
    create sequence dbo.NewsIdSequence as int start with 1 increment by 1;
  end;

create table Lang (
    id int not null
  , name nvarchar(64)
  , alias nvarchar(64)
  , constraint pk_Lang primary key clustered (id)
  , constraint uq_Lang_Name unique (name)
  );
  
create table NewsLanguage (
    news_id int not null 
     constraint df_NewsLanguage_news_id default (next value for dbo.NewsIdSequence)
  , lang_id int not null
  , title   nvarchar(256) not null
  , article nvarchar(max) not null
  , constraint pk_NewsLanguage primary key clustered (news_id, lang_id)
  , constraint fk_langLanguage_lang_id foreign key (lang_id) references lang(id)
  );
  
insert into Lang (id, Name, alias)
  select top 3 langid, name, alias 
  from syslanguages 
  order by langid;

declare @NextNewsId int;
set @NextNewsId = next value for dbo.NewsIdSequence;

insert into NewsLanguage( news_id, lang_id, title, article) 
            select @NextNewsId, 0, 'Hello', 'Hello ... ' 
  union all select @NextNewsId, 1, 'Hallo', 'Hallo ... '
  union all select @NextNewsId, 2, 'Bonjour',  'Bonjour ...';

set @NextNewsId = next value for dbo.NewsIdSequence;

insert into NewsLanguage( news_id, lang_id, title, article) values
  (@NextNewsId, 0, 'Goodbye','Goodbye ...' )
, (@NextNewsId, 1, 'Auf Wiedersehen', 'Auf Wiedersehen ...' )
, (@NextNewsId, 2, 'Au Revoir', 'Au Revoir ...');

select * 
from dbo.NewsLanguage nl 
    inner join dbo.Lang l on nl.lang_id = l.id

View schema
Execution time: 0,02 sec, rows selected: 8, rows affected: 9, absolute service time: 0,16 sec