Okay, this is a 3 part problem to:
"get the number at the end of the string and increment it by one as an Sql statement?"
So break it down and use the power of Google to help you:
1. find the index of the last of a non-numeric character:
sql get last alpha character index - Google Search[
^] gives us this:
Sql find the last non-numeric character in a string [duplicate][
^]
2. then you can increment the numeric value
3. lastly, concat/join the string back together:
sql concat string - Google Search[
^] - there are a number of examples.
Hope this helps!