To do so we need to use ROWNUM Pseudocolumn as follows :

SELECT ROWNUM "S.N.", Column_name(s) FROM Table_name;