Sorry for the late response!
You can generally play them in any order, but just know that the prologue is more accurate (writing wise) to the actual game ^^
The demo isn't necessary, but if you do want to try it you'll have to keep in mind that at this point it's not really connected to the full game in terms of story, and is extremely old art wise.
Thanks!