Depending on the indexes and other magic, more efficient might be:

select * from users where name = 'Captain Nemo' and id = (select min(id) from users where name='Captain Nemo')

trying to forget bad memories of forcing the Oracle query planner into submission with more hints than actual sql