increment counter in VIEW

Dear All,
Does anybody know how to add increment counter column to VIEW? To get
something like this

cntrColumn | anotherCol
------------------------
1                 |  val1
2                 |  val2
3                 |  ..
4                 |

The best if this counter will be executed together with sort to ensure
that sertain record gets always the same Counter value.

Thanks a lot in advance
Oleg