Survey module stores fixed question id in mdl_survey table (hard-coded in install.php) instead of storing dynamic question id from survey_questions table, due to that in case of cluster when questions are not in sequential order in mdl_survey_questions table questions are not displaying.
To Reproduce.
1) In MySQL my.ini add following line
auto_increment_increment =3
2) Restart MySQL and install Moodle.