set @var = 0;

select @var:[email protected]+1 , id,other_cols from tb ;