Query explicit Id

Hi, how can I add an ID field to a query, that should start with 1 (first record) and end with last record? It's a continuous number field. My query conatains two fields: firstname, productid