I would do:
int id = model->index(index.row(), 1).data().toInt();
The sequence of the columns in the query is the same as in the model and the view so 0=name, 1=id. The model is obtained either directly from the class where you have it or from the view using QListView::model().