To select rowid along with all other columns from a table, just use an alias and get the columns using asterisk (*).

select rowid as id, mm.* from MOVIES_MASTER mm where MOVIE_ID = 98766;