How to count id up in sql?

I want to create a small quiz and I have all the questions in my sql which kinda looks like this :

id question
1 how long…?
2 how many…?

I want to start with question with id=1 and after a click on a button the id counts +1, so the next question will be shown. Right now this is my code :

 ```<?php    $  sql='SELECT * FROM questions LIMIT 1';   $  result=$  mysqli->query($  sql);   $  questions= $  result->fetch_assoc();    if(isset($  _POST['button1'])) {   echo '<br>' .$  questions['question'] ;   $  questions= $  questions['id'+1];}?>``` 

Thanks in advance for any help 🙂