SQL Server 'FETCH FIRST 1 ROWS ONLY' Invalid usage

You can use top() finction'

select top 1 * from table

use top:

select top 1 * from products.series where state = 'xxx' order by id 

Try with OFFSET clause

select * from products.series where state = 'xxx' order by id 
OFFSET 0 ROWS
FETCH NEXT 1 ROWS ONLY