Should I index an integer column which is already ordered?
Inserting in an order does not mean that is a natural order in the table. 

Put a composite primary key on:

user_id, question_id  

A second index on question_id is optional.
It would only be used if you are searching on question_id only.